Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “plafond” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
plafond134418(None) 
plafonds1443271plafonds
placoid1239772placoid
aland65526413ala__nd
almond91410433al_mond
bland85320453bla__nd
blazon1736763blazon_
blazoned2044313blazoned
blazons1836163blazons
blond85618373bl__ond
claxon1536583claxon_
claxons1635803claxons
diamond1186113diamond
eland65820393ela__nd
flacon1138633flacon_
flacons1238053flacons
flagon1037983flagon_
flagons1137973flagons
flavone1335523flavone
fond86330953___fond
gland75217713gla__nd
klaxon1733853klaxon_
klaxons1833263klaxons
lagend838743_lagend
land56337313_la__nd
paeon74819493p_aeon_
paeons83915523p_aeons
pagod95013683p_ago_d
peafowl1543193peafowl
piaffed1693753piaffed
pinfold1336233pinfold
placard1236783placard
placed114318003pla_ced
placid114012543pla_cid
placing123815283placing
placoids1347343placoids
plagued11307473plagued
plaid85118303pla__id
plaided11409643plaided
plain74823303pla_in_
plained103812233plained
plains85019593pla_ins
plaint85323203pla_int
plaited103713893plaited
plan65833943pla__n_
plane74929143pla__ne
planed94420913pla_ned
planform1544753planform
planing103418253planing
plank115221143pla__nk
planked143512283planked
planned103810153planned
plans75731273pla__ns
plant75437113pla__nt
planted103516123planted
plashed133712643plashed
plasmid12239553plasmid
plasmoid1345583plasmoid
plasmon11257983plasmon_
plasmons12217663plasmons
plastid102112523plastid
platan83913693platan_
platane93112303platane
platans93413123platans
plated95225773pla_ted
platen84518203platen_
platens94213983platens
platform1544583platform
platina94413643platina
plating103823073plating
platonic1238773platonic
platoon938953platoon
platooned1244403platooned
platoons1038683platoons
platted103614263platted
played124815033pla_yed
playing133816093playing
playland1444573playland
playoff1843533playoff
pleon74216383pl_eon_
pleons84213343pl_eons
plod76723273pl__o_d
plonk114613983pl__onk
pluton838853pluton_
plutons938343plutons
plywood1645133plywood
polaron939843polaron_
polarons1039863polarons
pond75530493p___ond
prefund1335733prefund
profound1444923profound
seafood1146153seafood
unfond10149113_unfond
upland938863upla__nd

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit134027946.40620922.1
3Display Results94940.0462043.5
 (SQL Overall)178691946.85826055.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.