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

97 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
redpoll104504(None) 
redpolls1144011redpolls
repoll8410791re_poll
bedroll1055552bedroll
redrill857892redrill
repolls939052re_polls
reroll6412682re_roll
respell947022respell
respool937642respool
beadroll1144503beadroll
bedell93610043bed_ell
bedpost1247243bedpost
bedrolls1144673bedrolls
clodpoll1341813clodpoll
despoil1046523despoil
doll56632493__d_oll
droll65415403__droll
enroll61110073_enroll
extoll1334863_extoll
outpoll946793outpoll
poll66332133___poll
predrill1145933predrill
prepill1147593pre_pill
rampole1139693rampole
reapply1434323reapply
rebill84713253re_bill
reboil83814693re_boil
recall83815733re_call
recoal84117983re_coal
recoil84016723re_coil
redbone1037973redbone
redcoat10410883redcoat
reddle83815913red_dle
redeploy1453173redeploy
redial74923113red_ial
redials84416893redials
redly94217203red__ly
redo56029373red_o__
redock134311543red_ock
redoes74623773red_oes
redon65424883red_o_n
redone74820053red_one
redons75222183red_ons
redos65126763red_o_s
redout71820253red_out
redowa1038453red_owa
redox134714233red_o_x
redrills956083redrills
redroot8312903redroot
redrove11249423redrove
redtail858713redtail
redtop937973redto_p
redtops1037383redtops
redwood1236523redwood
reenroll843543reenroll
refall94314393re_fall
refell94214443re_fell
refill94514053re_fill
refold103812113re_fold
remold93412973re_mold
reoil55321183re__oil
repeal84718293re_peal
repel74921403re_p_el
repels84318763re_pels
replot83818593re_plot
replow114210343re_plow
reply104015853re_p_ly
repo66027543re_po__
repolled11359623re_polled
report85326023re_port
repos74725793re_po_s
reposal939113re_posal
repose84121413re_pose
repot75132623re_po_t
repots85621003re_pots
repour8310993re_pour
rerolls739943re_rolls
resell64215203re_sell
resold73915363re_sold
resole64624183re_sole
respells1056333respells
respelt9312143respelt
respoke134311283respoke
respond1039113respond
respools1036263respools
respot83117633respo_t
respots92912773respots
retell63813643re_tell
retold73013753re_told
retool63914483re_tool
retools73411023retools
revolt9316223re_volt
roll46331653r___oll
tadpole1036143tadpole
wadmoll1352903wadmoll
zeppole2043493zeppole
zeppoli2042133zeppoli

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 Limit134027977.23318529.9
3Display Results97970.0462108.7
 (SQL Overall)178691977.68523251.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.