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

224 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
blate7593378(None) 
ablate82219211ablate
alate55340321alate
bate66552421b_ate
blade85923331blade
blae66134641bla_e
blame95625491blame
blare75826231blare
blase75524231blase
blat66550951blat_
blats75132501blats
blaze165520831blaze
blite76225351blite
elate55335881elate
late47560481_late
oblate82214741oblate
plate74635111plate
slate55438281slate
abate76627842abate
ablated102513442ablated
ablates92416902ablates
ablaze17239832ablaze
agate66525142agate
alae45643752ala_e
alane56135612alane
alated75625142alated
alates64833962alates
ate37059242__ate
babe86835822b_abe
bade75140882b_ade
bake105637512b_ake
balata8614672balata
bale66353842b_ale
bane65250422b_ane
bare65460522b_are
base64847022b_ase
baste74829982baste
bat510988952b_at_
bated85935532b_ated
bates75846342b_ates
bath95940082b_ath
bathe105822882b_athe
bats66962332b_ats
batt65053872b_att
beat66168302beat_
beaten84617062beaten
beater84729392beater
beats76042242beats
belated103520012belated
berate84729022berate
binate8419772binate
bite66547002b_ite
blab86629132bla_b
blabs95619632blabs
black134719072black
bladed104717762bladed
blader93618582blader
blades95221252blades
blaff135216482blaff
blah98625062bla_h
blahs105616512blahs
blain75421792blain
blam86131702bla_m
blamed116017952blamed
blamer104417142blamer
blames105121862blames
blams95023852blams
bland85320452bland
blank115418552blank
blared95018242blared
blares85021632blares
blast76532572blast
blasted104213472blasted
blaster94017302blaster
blastie92411392blastie
blasts85116772blasts
blasty115611052blasty
blather125314202blather
blatted104812712blatted
blatter94415652blatter
blaw97026722bla_w
blawed124713892blawed
blawn106813702blawn
blaws105620462blaws
blazed184314712blazed
blazer174414022blazer
blazes174817352blazes
bleat75737002bleat_
bleated104015972bleated
bleater94515302bleater
bleats85518612bleats
blet66247672blet_
blets75324942blets
blites84721212blites
blithe115810862blithe
blitz165318132blitz
bloat75229922bloat_
bloated104513432bloated
bloater94013422bloater
bloats85215762bloats
bloke114316632bloke
blot65842322blot_
blots75626172blots
blue65328462bl_ue
bluet75631192bluet
blume95619892blume
blype12429672blype
boat66360312boat_
boated94221972boated
boatel84314092boatel
boater84622092boater
boats75635152boats
boite74426322boite
bolete8519612bolete
borate85026152borate
brace95629272brace
brae65639112bra_e
brake116025342brake
brat66055542brat_
brats75336012brats
brave104925502brave
braze165423452braze
brute75321782brute
bullate93415072bullate
bute66739672b_ute
butte74924292butte
byte96521812b_yte
cate66254592_cate
clade85821012clade
clave105420152clave
crate76537402crate
date56443322_date
delate73827752delate
dilate73220692dilate
elated74725822elated
elater64724202elater
elates65032362elates
elite56230182elite
eluate62315432eluate
elute54822572elute
enate54428142enate
fate75444282_fate
flake125119972flake
flame105124442flame
flare84823632flare
flat77147822flat_
flats86429742flats
flite85424962flite
flute86823752flute
flyte115713942flyte
folate93320392folate
gate55746572_gate
gelate73421252gelate
glace87420152glace
glade75121962glade
glare65222952glare
glaze155418162glaze
glute66020902glute
grate64932882grate
hate78450172_hate
irate55627982irate
lace66848472_lace
lade56345982_lade
lake85741602_lake
lame66849292_lame
lane45153322_lane
lase46148512_lase
lat37593402_lat_
lated65240672_lated
laten54328342_laten
later54843922_later
latex124717112_latex
lath76640382_lath
lathe85626712_lathe
lati46438272_lati
latke94817092_latke
lats45962702_lats
latte55426302_latte
latu47934182_latu
lave75642142_lave
laze136235052_laze
lite47054542_lite
lute46341012_lute
malate84624552malate
mate65154212_mate
oblates91913242oblates
oleate6318882oleate
orate55133302orate
ovate84214392ovate
palate84226782palate
pate65350462_pate
place94824612place
plage84520402plage
plane74929142plane
plat66048872plat_
plated95225772plated
platen84518202platen
plater84427692plater
plates85432242plates
plats75531372plats
platy105021662platy
prate75135982prate
quate144521412quate
rate45458762_rate
relate64033632relate
sate45556102_sate
skate94721542skate
slake93724052slake
slat46959022slat_
slated75028312slated
slater64429182slater
slates64934062slates
slatey95417062slatey
slats55436902slats
slaty86523152slaty
slave84224032slave
solate64526072solate
spate74731582spate
state56237332state
sublate9315362sublate
tate44748602_tate
urate55432162urate
velate93720142velate
zlote143912942zlote

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 Filter178691538000.0931921408.6
2DLD Change Limit538002241.96627365.2
3Display Results2242240.1261777.8
 (SQL Overall)1786912242.18581780.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.