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 “poilu” with Change Limit: [1] [2] [3]

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

60 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
poilu7231600(None) 
poilus82210571poilus
boil66335182boil_
boils75427192boils
coil66439652coil_
coils75030082coils
doily95321032doily
foil76433912foil_
foils85025812foils
moil65534092moil_
moils76125752moils
noil46133242noil_
noils55024332noils
noily86120992noily
oil37452052_oil_
oils46337972_oils
oily77932252_oily
pail66141832pail_
pails75833062pails
pilau73618522p_ilau
pile65649692p_ile
pili66130352p_ili
pill65339462p_ill
pilus75921062p_ilus
pily96132732p_ily
piu56639542p_i_u
poi57244662poi__
poind84217912poind
point75338732point
pois66539042poi_s
poise75127892poise
pokily15309062pokily
pol56449382po_l_
pole65951302po_le
polio75722552polio
polis74731162polis
poll66332132po_ll
polls74627722polls
polo66236632po_lo
pols66044562po_ls
poly96235152po_ly
pool65835952pool_
pools74427702pools
poult76928872poult
poyou102611522poyou
prill74117942prill
roil46235292roil_
roils54826792roils
roily86121112roily
soil46138832soil_
soils55327982soils
spoil75818652spoil_
spoils84614532spoils
spoilt85016592spoilt
toil46536282toil_
toile54626492toile
toils54527492toils
tolu45529152to_lu
voila84813942voila
voile84719722voile

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit53800601.61033416.1
3Display Results60600.0163750.0
 (SQL Overall)178691601.95291542.5
 
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.