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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
truce7511869(None) 
trace75829611trace
trice75127491trice
truced95312051truced
truces84916331truces
truck116115461truck
true46725851tru_e
brace95629272brace
brume95817982brume
brute75321782brute
cruces105117542cruces
cruck135615322cruck
crude86018572crude
cruse75726102cruse
deuce84517492deuce
douce85518422douce
drupe85012992drupe
druse64817662druse
duce76933502_duce
educe84313452educe
eruct74022352eruct
grace85124542grace
grue55825712gru_e
grume86218162grume
luce65132572_luce
price93725412price
prude84615972prude
prune75119632prune
puce85127882_puce
race66746262_race
rice64942912_rice
rube65532012_rube
ruche104216762_ruche
ruck104728332_ruck
rude55632782_rude
rue35549262_ru_e
rule49938422_rule
rune45236302_rune
ruse45938932_ruse
sauce75121652sauce
spruce103910872spruce
struck12489262struck
tace65342512t_ace
taupe7314162taupe
terce75721842terce
teuch105214852teuch
thrice114311572thrice
touch106519392touch
touche114916172touche
touse55430672touse
traced94821582traced
tracer84820232tracer
traces85329932traces
track114823012track
tract75635712tract
trade65026042trade
traduce1036352traduce
trance84718762trance
trave85223032trave
tree47745812tr_ee
tribe74420272tribe
triced95518672triced
tricep103911072tricep
trices84826332trices
trick115420692trick
trike95320162trike
trine54734602trine
tripe75425382tripe
trite54730032trite
triune64210182triune
troche113112512troche
trock114817602trock
trode65322852trode
troke94821052troke
trone55131862trone
trope75725802trope
trounce936822trounce
troupe84812432troupe
trove85221922trove
trucked143910812trucked
trucker134010732trucker
truckle13358862truckle
trucks124711972trucks
trudge8318732trudge
trued65117692trued
truer54916642truer
trues54925322trues
truffe1276232truffe
trug55720042tru_g
trugs65516802trugs
trull54012672trull
truly84111552truly
trump95615122trump
trunk94713042trunk
truss54916922truss
trust55426852trust
truth85214152truth
tube65828662t_ube
tuck104626572t_uck
tule45735872t_ule
tune45635862t_une
twice104711122twice

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.313570897.8
2DLD Change Limit538001021.45337026.8
3Display Results1021020.0303400.0
 (SQL Overall)1786911021.79699493.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.