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

100 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
respooled124559(None) 
despoiled1344652despoiled
repolled11359622re_polled
reschooled1643022reschooled
resoled84119282res__oled
respelled1257072respelled
responded1336512responded
respool937642respool__
respools1036252respool_s
respotted1235952respotted
retooled938472re_tooled
spooled104613522__spooled
unspooled12254912unspooled
befooled1434803be_fooled
bespoused1443773bespoused
carpooled1445073carpooled
despoiler1243963despoiler
desponded1445323desponded
dewooled1333833de_wooled
espoused1134863_espoused
festooned1344303festooned
pooled94619813___pooled
precooled1446363pre_cooled
rebloomed1453283rebloomed
reboiled11349393re_boiled
rebooked15226503re_booked
rebooted11248463re_booted
recoaled113111793re_coaled
recoiled113613223re_coiled
recooked15268253re_cooked
reflooded1443553reflooded
regroomed1344163regroomed
regrooved1443263regrooved
relooked13236653re_looked
reoiled84316853re__oiled
reopposed1444343reopposed
repealed113211873re_pealed
repelled113111593re_pelled
repeopled1444393repeopled
repled93319783re_p__led
replowed14127583re_plowed
reported11312703re_ported
reposed103616283re_p_osed
repotted1139283re_potted
repoured1139563re_poured
reprobed13228753re_probed
reproved14199483re_proved
rerolled93010063re_rolled
reroofed1235883re_roofed
resaddled1294253resaddled
resailed93613063res_ailed
resampled1454113resampled
rescaled113311303res_caled
rescored114513103res_cored
resealed92713973res_ealed
resembled1445173resembled
resettled1035303resettled
reshoed112212153res_ho_ed
reshowed15117063res_howed
resiled84621983res__iled
resmoothed1642563resmoothed
resoaked1337943res_oaked
resodded1136353res_odded
resold73915363res__ol_d
resole64624183res__ole_
resoles73823653res__oles
resolved12349343res_olved
resorbed1138533res_orbed
resorted9313493res_orted
resowed113712263res__owed
respaced1338503resp_aced
respaded1238133resp_aded
respected1438493respected
respired1148993resp_ired
respited11410813resp_ited
respliced1445543respliced
respoke134311283resp_oke_
respoken14506923resp_oken
respond1039113resp_o_nd
responder1246453responder
response1037753response_
responses1147453responses
respooling1355743respooling
resprayed1544353resprayed
resprouted1344223resprouted
restabled12148963restabled
restocked1655173restocked
restoked135710533res_toked
restored96417193res_tored
restyled1236953res_tyled
shooled115212663__shooled
snooled84513943__snooled
spoiled104811353__spoiled
spoofed13399103__spoofed
spooked144510473__spooked
spooler93711383__spooler
spooned103412443__spooned
spoored104411293__spoored
stooled84313893__stooled
unspoiled12255563unspoiled

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.440406115.9
2DLD Change Limit1486411006.62322443.2
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.10925135.9
 
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.