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

83 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
quills15381185(None) 
quells15359701quells
quill148413771quill_
quilts154112541quilts
quolls15327301quolls
squills1666311squills
bills75632862_bills
brills84916292brills
builds9378492builds
bulls75629572bu_lls
chills114717702chills
culls75425812cu_lls
dills65530972_dills
drills74414202drills
dulls64523742du_lls
fills84632372_fills
frills94414222frills
fulls84623522fu_lls
gills64728192_gills
grills74314802grills
guilds8388352guilds
guiles73919282guiles
guilts74111232guilts
gulls65222982gu_lls
hills85431352_hills
hulls84923562hu_lls
ills47030422__ills
jills125122822_jills
kills94526172_kills
krills104211282krills
lulls54119652lu_lls
maills84215282maills
mills75435052_mills
mulls75124152mu_lls
nills54926672_nills
nulls55019982nu_lls
pills74130972_pills
prills84015612prills
pulls74425052pu_lls
quails153412642quails
qualms17317242qualms
quell144311432quell_
quicks21389302quicks
quids154917462qui_ds
quiets154014372quiets
quiffs21135432quiffs
quillai1644992quillai
quillais1745002quillais
quilled17329282quilled
quillet162713232quillet
quillets17256822quillets
quilt144125102qui_lt
quinols16297242quinols
quins144819852qui_ns
quints154316562quints
quips164713372qui_ps
quipus17458002quipus
quires154015752quires
quirks19419112quirks
quirts154213552quirts
quits144122352qui_ts
quoll14379492quoll_
rills55032712_rills
shills94519612shills
sills55135992_sills
skills104313922skills
spills84717462spills
squalls1647312squalls
squill1537232squill_
squilla1635532squilla
squillas1745332squillas
stills64118572stills
swills94213362swills
thills95515382thills
tills54631712_tills
trills64319852trills
tuille63012642tuille
tuilles72411922tuilles
twills9489792twills
vills86429322_vills
wills84528962_wills
yills83921552_yills
zills144020782_zills

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551832.34335233.0
3Display Results83830.0165187.5
 (SQL Overall)178691832.70266132.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.