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 “derrieres” 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.

77 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
derrieres104481(None) 
derriere936041derriere_
decriers11299732decrier_s
derries83124622derri__es
derrises93012782derri_ses
terriers84210822terrier_s
barriers104311883barrier_s
bergeres1189113be_rgeres
berries94423553berri__es
carriers103614203carrier_s
currieries1244533currieries
curriers103410753currier_s
dearies83526273deari__es
debrides1268723debri_des
debriefed1642143debriefed
debriefer1541923debriefer
debriefers1641653debriefers
debriefs1433533debrie_fs
deciares11510633de_ciares
decreers11277623decreer_s
decrees102513123decr_e_es
decrier102713553decrier__
decries103319803decri__es
defiers113913993de_fier_s
degrees92810723degr_e_es
deifiers12348993deifier_s
deniers84515183de_nier_s
deprivers1545213depriver_s
deprives1438393depri_ves
derbies103016053derbi__es
deriders102411853derider_s
derides93420853de_ri_des
derivers123811363deriver_s
derives114017813de_ri_ves
dermises112512023dermi_ses
dernier83011943dernier__
derricks1544433derri_cks
derringer1144593derringer
derringers1243843derringers
derris73615273derri___s
dervishes1644933dervishes
descriers1245693descrier_s
desirers939263desirer_s
desires81316133de_si_res
destriers1038143destrier_s
driers74516733d__rier_s
durries83817353durri__es
farrieries1344343farrieries
farriers113610743farrier_s
ferriages1345663ferriages
ferries103521083ferri__es
ferrites112312833ferri_tes
furrieries1343943furrieries
furriers11369493furrier_s
harriers113712433harrier_s
herries104025073herri__es
hurriers11358893hurrier_s
jerries143817513jerri__es
kerries113317913kerri__es
marriers103312473marrier_s
merrier92612303merrier__
parriers103612903parrier_s
perries93226603perri__es
portieres1138213portieres
premieres13288233premieres
reprieves1475113reprieves
retrieves1265653retrieves
serries73925353serri__es
tarriers83411713tarrier_s
terrenes82212603terr_enes
terrier73414963terrier__
terries73425633terri__es
terrifies12139723terrifies
terrines82117553terri_nes
verniers11227843vernier_s
worriers11257813worrier_s
xeroseres1644683xeroseres

Search took 8 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 Filter1786911486410.406440125.6
2DLD Change Limit148641777.22020587.4
3Display Results77770.0332333.3
 (SQL Overall)178691777.65923330.9
 
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.