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

122 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
quate14452141(None) 
equate152012461equate
quake184114641quake
quale143617851quale
quare143920541quare
quarte154115321quarte
quatre153512351quatre
quite144621461quite
quote143714771quote
abate76627842abate
acuate8315632acuate
agate66525152agate
alate55340332alate
aquae142212712aqua_e
ate37059242__ate
aurate64426472aurate
bate66552422_bate
blate75933782blate
bute66739672bu_te
butte74924292butte
cate66254602_cate
crate76537402crate
curate85226242curate
cute66440452cu_te
date56443322_date
elate55335882elate
eluate62315432eluate
enate54428152enate
equated171910402equated
equates162012322equates
fate75444282_fate
gate55746572_gate
grate64932882grate
hate78450172_hate
haute89521612haute
humate113214442humate
irate55627982irate
jugate14379462jugate
jute115327892ju_te
late47560482_late
liquate1638422liquate
lunate6316042lunate
lute46341012lu_te
luxate1338082luxate
mate65154222_mate
mutate83017482mutate
mute65136872mu_te
nutate63017372nutate
orate55133302orate
outate62923402outate
ovate84214392ovate
pate65350462_pate
plate74635112plate
prate75135982prate
pupate104213122pupate
qat125253332q_at_
qats135331342q_ats
qua124821972qua__
quack203812502quack
quad144618702qua_d
quads154515842quads
quaere154110672quaere
quaff201311352quaff
quag144815942qua_g
quags154613252quags
quai134420392qua_i
quail144314362quail
quais144618392quais
quaked203910032quaked
quaker193811622quaker
quakes194013342quakes
quaky214310742quaky
qualm163511182qualm
quant143624812quant
quanta153911332quanta
quanted1738962quanted
quants153614142quants
quark184614122quark
quart144027852quart
quarter163211852quarter
quartes163314932quartes
quartet162814892quartet
quarto153511122quarto
quarts154715932quarts
quartz244212102quartz
quash174512162quash
quasi144015022quasi
quass144413762quass
quatres163411932quatres
quaver18309312quaver
quay164618352qua_y
quays174612042quays
qubyte2034242qubyte
queue143711232queue
quiet144530732quiet
quinate16511572quinate
quinte153414522quinte
quire144917132quire
quit136136512quit_
quits144122352quits
quota145111962quota
quoted16359452quoted
quoter153510092quoter
quotes153312462quotes
quoth173310352quoth
rate45458762_rate
rugate75813812rugate
sate45556102_sate
saute55028082saute
skate94721552skate
slate55438282slate
spate74731582spate
square154513362square
squat143720142squat_
squats153712962squats
state56237332state
suave83519872suave
suite54829562suite
tate44748602_tate
tubate82813172tubate
urate55432162urate
ute35335882_u_te

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 Limit538001221.34340059.6
3Display Results1221220.0304066.7
 (SQL Overall)1786911221.686105985.2
 
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.