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

116 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
recheck183561(None) 
precheck2144151precheck
rechecks1944551rechecks
check164714712__check
forecheck2342772forecheck
prechecks2243572prechecks
rebeck14419912re_beck
recheat12415932recheat
rechecked2143972rechecked
rechew14310212reche_w
rechews1537292rechews
recock145112722rec_ock
redneck1445112redneck
aircheck1942903aircheck
bechalk1845813bechalk
bedeck1536213be_deck
befleck1843943befleck
checks174912703__checks
cheek145115713__cheek
chick165419133__chick
chock164316613__chock
chuck164814873__chuck
creche13310763creche__
creches14313093creche_s
crewneck1942123crewneck
eche97520283_eche__
eched116919223_eche_d
eches106322163_eche_s
forechecks2462523forechecks
hatcheck2244013hatcheck
heck135826493___heck
henpeck1843083henpeck
leched123716003leche_d
lecher113415853leche_r
lechers123313963lechers
lechery15257643lechery
leches115421313leche_s
paycheck2442553paycheck
peched144915343peche_d
pincheck2143383pincheck
prechecked2443083prechecked
rachet115028973rache_t
rachets124516833rachets
raincheck2041903raincheck
reached134619083reache_d
reacher123718293reache_r
reachers133515723reachers
reaches123423203reache_s
rebec94416543re_bec_
rebecks15288013re_becks
rebecs103913673re_becs
recce9514563rec__ce
recces10614913recce_s
recede95515533rec_ede
recency1438633recency
recent83630853rec_ent
recept103319083rec_ept
recess8314263rec_ess
rechart12314343rechart
recheats1339193recheats
rechecking2244463rechecking
recherche1942903recherche
rechewed1735633rechewed
rechose121312053rechose
reck106130563r___eck
recked134821803recke_d
reclean938523reclean
recocks154711463rec_ocks
recook125513923rec_ook
recork126315493rec_ork
redhead1257053redhead
rednecks1544013rednecks
redock134311543re_dock
reeject16349623reeject
reek85232523re__e_k
reelect911515633reelect
reerect92915883reerect
refect114319333re_fect
reflect123913713reflect
rehear93713223re_hear
reheat94423943re_heat
reheel93610823re_heel
rehem103815353re_he_m
rehems113410983re_hems
reject154116283re_ject
relock124713523re_lock
repack142412163re_pack
reperk122511773re_perk
rerack122513163re_rack
resect84424703re_sect
reseek103813133re_seek
reshes94124363reshe_s
respeak1335933respeak
respect11412033respect
restack1339433restack
restock1338673restock
retack122612823re_tack
retched133814273retche_d
retches123318513retche_s
rethink1488883rethink
retrack131310723retrack
richen113812513riche_n
richens12349733richens
richer114015043riche_r
riches115022083riche_s
richest122813683richest
rochet115423003roche_t
rochets124213473rochets
ruche104216763ruche__
ruched124314633ruche_d
ruches114819583ruche_s
secrecy1444743secrecy
sidecheck2151773sidecheck
teched124014433teche_d
upchuck2041943upchuck
zebeck23255203ze_beck

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271167.30018359.9
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.75223051.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.