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

102 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
reproof123878(None) 
reproofs1346061reproofs
reroof9315001re_roof
fireproof1743702fireproof
proof105221532__proof
redroot8312902redroot
regroom1077302regroom
repro75315912repr_o_
reprobe112310132reprobe
repros84216002repr_os
reprove122911072reprove
reroofs1037942re_roofs
wetproof1643762wetproof
airproof1345133airproof
bedroom1247083bedroom
behoof1458683be_hoof
disproof1446253disproof
enroot6615993_enroot
fireproofs1852633fireproofs
germproof1752113germproof
heatproof1753823heatproof
hereof123212373he_reof
leakproof1852443leakproof
legroom1076093legroom
leprose938543leprose
leprosy1244223leprosy
leprous938843leprous
oilproof1353663oilproof
ovenproof1752443ovenproof
overproof1745533overproof
poof95541663__p_oof
prof96134663__pr_of
proofs114511683__proofs
rainproof1453043rainproof
reaphook1743613reaphook
rebloom1145663rebloom
rebook125213203re_book
reboot84119333re_boot
recook125513923re_cook
recross989833recross
recrown12257573recrown
redroots937753redroots
redrove11249423redrove
redwood1236523redwood
reflood1136363reflood
refront10313263refront
refroze1956223refroze
regrooms1196013regrooms
regroove1243673regroove
regroup1095173regroup
regrow10309883regr_ow
regrown11237363regrown
regrows11269153regrows
relook104813743re_look
replot83818593rep_lot
replots93412633replots
replow114210343rep_low
replows12329703replows
repo66027543rep__o_
repoll8410793rep_oll
report85326023rep_ort
reports94916213reports
repos74725793rep__os
repose84121413rep_ose
repot75132623rep__ot
repots85621003rep_ots
repour8310993rep_our
repress92712683repress
reprice113212833reprice
reprint9318983reprint
reprise92715043reprise
reproach1544953reproach
reprobed13228743reprobed
reprobes121910293reprobes
reproval1355773reproval
reproved14199473reproved
reprover13229203reprover
reproves132011473reproves
reroll6412683re_roll
reroofed1235873re_roofed
rerose63320843re_rose
reshoot102513893reshoot
respool937643respool
resprout1078783resprout
restroom1047573restroom
retook104313443re_took
retool63914483re_tool
retro55020953retr_o_
retros63820193retr_os
rewrote1039123rewrote
ripoff1436433rip_off
roof75738833___roof
rustproof14132883rustproof
spoof105019013_sp_oof
sunproof1344603sunproof
sunroof1047053sunroof
taproom1147963taproom
taproot9412673taproot
tearoom939063tearoom
unroof9410193_unroof
uproot8314123_uproot
wearproof1753033wearproof

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271026.44020811.6
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.87625987.6
 
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.