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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 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
reappears134285(None) 
reappear1242621reappear_
appears11308952__appears
coappears1542952coappears
rappers113618442r_appe_rs
reapers93520452rea_pe_rs
reappeared1543012reappeared
repapers1258832repape_rs
appeals11378673__appeals
appear10379343__appear_
cappers134419403_cappe_rs
clappers143310833clappe_rs
coappear1442893coappear_
crappers144011023crappe_rs
disappears1542563disappears
flappers15388383flappe_rs
headgears1443153headgears
heapers123616673hea_pe_rs
knappers16315643knappe_rs
lappers113717463_lappe_rs
leapers93716663lea_pe_rs
mappers133313783_mappe_rs
nappers114214863_nappe_rs
peppers103311443pe_ppe_rs
rapers84327183r_a_pe_rs
rapiers95012873r_apie_rs
rappees113611453r_appe_es
rappels11448803r_appe_ls
rapper104621573r_appe_r_
raspers94415923r_aspe_rs
reachers133515723reache_rs
readers83823773rea_de_rs
realgars934533rea_lgars
realters83614043realte_rs
reamers94221083rea_me_rs
reaper84223143rea_pe_r_
reappearing1643943reappearing
reapplies1344923reapplies
reappraise1453323reappraise
rearers74323563rea_re_rs
reavers108320743rea_ve_rs
redears82814453re__dears
regears83012463re__gears
rehears103312773re__hears
relapsers1164123relapse_rs
repaper11310023repape_r_
repeals94014523re__peals
repeats94316053re__peats
repleads11357213re_pleads
rerepeats1145263rerepeats
respeaks1434953re_speaks
respreads1244523respreads
retears72814923re__tears
revampers1653443revampe_rs
rewears102911043re__wears
rippers114115033r_ippe_rs
sappers113518903_sappe_rs
slappers123710953slappe_rs
snappers123510173snappe_rs
swappers15358083swappe_rs
tappers113416543_tappe_rs
trappers123711043trappe_rs
whappers18276743whappe_rs
wrappers15306933wrappe_rs
yappers144012253_yappe_rs
zappers203911633_zappe_rs

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 Filter1786911486410.420425454.8
2DLD Change Limit148641667.11020905.9
3Display Results66660.0302200.0
 (SQL Overall)178691667.56023636.4
 
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.