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

77 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
redpolls114401(None) 
redpoll1045041redpoll_
repolls939051re_polls
bedrolls1144672bedrolls
redrills956082redrills
repoll8410792re_poll_
rerolls739942re_rolls
respells1056332respells
respools1036252respools
beadrolls1243773beadrolls
bedells10379363bed_ells
bedposts1343873bedposts
bedroll1055553bedroll_
clodpolls1451803clodpolls
despoils1145623despoils
dolls66126923__d_olls
drolls75312393__drolls
enrolls7108093_enrolls
extolls1444603_extolls
outpolls1046213outpolls
polls74627723___polls
predrills1244473predrills
rampoles1238893rampoles
rebills93510623re_bills
reboils94111723re_boils
recalls92613623re_calls
recoals94214623re_coals
recoils93814873re_coils
redbones1137593redbones
redcoats1147123redcoats
reddles93315773red_dles
redeploys1552513redeploys
redials84416883red_ials
redocks14409933red_ocks
redoes74623773red_o_es
redons75222183red_o_ns
redos65126763red_o__s
redouts81411663red_outs
redowas1138393red_owas
redoxes15310883red_oxes
redrill857893redrill_
redroots937753redroots
redtails968003redtails
redtops1037373redto_ps
redwoods1345773redwoods
reenrolls942993reenrolls
refalls103312243re_falls
refills103711423re_fills
refolds11298953re_folds
remolds10299703re_molds
reoils64516873re__oils
repeals94014523re_peals
repels84318763re_p_els
replots93412633re_plots
replows12329703re_plows
repolish1347933re_polish
repolled11359623re_polled
reports94916213re_ports
repos74725793re_po__s
reposals1037403re_posals
reposes94021263re_poses
repots85621003re_po_ts
repours9310233re_pours
reroll6412683re_roll_
resells73313203re_sells
resoles73823653re_soles
respell947023respell_
responds1136913responds
respool937643respool_
respots92912763respo_ts
retells73211523re_tells
retools73411023re_tools
revolts1038893re_volts
rolls55326233r___olls
tadpoles1135953tadpoles
wadmolls1442573wadmolls
zeppoles2143583zeppoles

Search took 10 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 Filter1786911461620.423422437.4
2DLD Change Limit146162779.23315830.4
3Display Results77770.0332333.3
 (SQL Overall)178691779.68918442.7
 
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.