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

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

146 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
ersatz153665(None) 
ergate7315142ergate
errata639012errata
ersatzes1743072ersatzes
erst47436432ers_t_
resat55139682resat_
aerate64830553aer_ate
aerosat7417183aerosat_
aerosats8411013aerosats
ansate64517863ansate
arhat8327093arhat_
arhats9312973arhats
berate84729023ber_ate
brat66055543br_at_
brats75336013br_ats
breath113916263breath
bursate94111203bursate
cerate84829463cer_ate
crate76537403cr_ate
create85126383create
derat65044083der_at_
derate74531233der_ate
derats74625063der_ats
drat56247833dr_at_
drats66628373dr_ats
east46659103eas_t_
easts57530323eas_ts
eat36989053e__at_
eath75735663e__ath
eats47054873e__ats
eclat7523603eclat_
eclats8313033eclats
elate55335883e_late
eluate62315433eluate
enate54428153e_nate
equate152012463equate
era35741503er_a__
eras45441503er_a_s
erase54925493er_ase
erased74816753erased
eraser64216333eraser
erases64425403erases
erect74129333erect_
erects84116183erects
ergates8314493ergates
ergot65422893ergot_
ergots74512373ergots
errand758793errand
errant6618733errant
errants7410643errants
erratas736863erratas
erratic9311123erratic
erratum944503erratum
ers36046283ers___
erses55826803ers_es
eruct74022353eruct_
eructs83610793eructs
erupt74220063erupt_
erupts8348903erupts
essay867623essa_y
essays965653essays
estate64719763estate
expat14313813expat_
expats1537683expats
fermata12278143fermata
fermate122813003fermate
ferrate103014043ferrate
frat75648543fr_at_
frats86829673fr_ats
fritz176020773fr_itz
grat55651283gr_at_
grate64932883gr_ate
great66034243great_
greats76318393greats
groat65531973groat_
groats74816653groats
hereat93527413hereat_
hertz174919043her__tz
irate55627983ir_ate
lysate9388103lysate
misate81222693misate
nertz145117453ner__tz
nervate1039533nervate
orate55133303or_ate
ornate6315143ornate
persalt9315413persalt
persalts1038193persalts
prat65952043pr_at_
prate75135983pr_ate
prats76333393pr_ats
rat37892743_r_at_
rate45458763_r_ate
rath76037663_r_ath
rato45436973_r_ato
rats46260373_r_ats
razz125219423_r_azz
reata54225393_reata
rebate84424113rebate
rebato83714683rebato
redate74124683redate
relate64033633relate
remate84428683remate
resaid74517083resaid
resail64418733resail
resale64025543resale
resaw84117253resa_w
resawn9399953resawn
resaws93713513resaws
resay85320543resa_y
resays93714153resays
reseat64131493reseat_
reseats74319583reseats
reset55051863reset_
resets65427613resets
resit54241043resit_
resite64128453resite
resits64725563resits
reslate73520593reslate
rest46459843res_t_
restate73824883restate
rests54935873res_ts
riata54618023_riata
ritz135129983_r_itz
sat36288483__sat_
sate45556103__sate
sati45539333__sati
sensate7311893sensate
seriate73722473seriate
serrate73017543serrate
ternate7415483ternate
treat56240353treat_
treats64821693treats
treaty94414353treaty
urate55432163ur_ate
ursa44116913ursa__
ursae55214453ursa_e
versal93013753versa_l
versant10313833versant
versants1137783versants
verset94327323verset_
versets103913103versets
verst84429373vers_t_
verste94515633vers_te
versts93914733vers_ts
wrath115715873wr_ath
wreath124111193wreath

Search took 7 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161465.98318839.4
3Display Results1461460.0502920.0
 (SQL Overall)1786911466.40927881.3
 
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.