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

85 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
rollover114445(None) 
rollovers1244091rollovers
allover1038582_allover
boilover1344022boilover
follower14137072follower
holdover1544082holdover
hollower14127402hollower
pullover13134642pullover
roller63919792roll__er
allovers1137673_allovers
balloter1078893balloter
bellower13159073bellower
boilovers1444103boilovers
bolloxed1834473bolloxed
bolloxes1736833bolloxes
callower13159073callower
clover114617123__clover
colleger11227933colleger
collider113410423collider
collier93618153coll_ier
colluder11276873colluder
colorer9312523co_lorer
crossover1484313crossover
dolloped1234983dolloped
droller84110283droll__er
flopover1642863flopover
flyover1633513_flyover
followed15146273followed
followers15146183followers
galloper11137193galloper
glover104513533__glover
groover11358543gro__over
hallower14139823hallower
holdovers1643763holdovers
holler93520613holl__er
holloaed12157393holloaed
holloed113812753hollo_ed
holloes103818193hollo_es
hollooed12146493hollooed
hollowed15157033hollowed
hoover124314433ho__over
jollier142911003joll_ier
loller63315283loll__er
lolloped1134463lolloped
lover85526453___lover
mellower13167413mellower
moreover1344863moreover
plover115312613__plover
poller83921853poll__er
pollster1037103pollster
polluter1035403polluter
popover1495843po_pover
pullovers14124243pullovers
rallier73816273rall_ier
recover124312623r_ecover
reflower14126853reflower
reliever11448683reliever
remover124612273r_emover
reprover13229203reprover
resolver11339793resolver
revolver14287713revolver
roilier7311523roil_ier
rolfer94412273ro_l_fer
rolled74220243roll__ed
rollers73117473roll__ers
rollout7811943rollo_ut
rollouts8136733rollouts
roofer94415283ro__ofer
roomer84718633ro__omer
rooser63921883ro__oser
rooter64926033ro__oter
rover85527373r___over
runover1034663r_unover
sallower11139503sallower
solver94016703so_l_ver
spillover1442623spillover
toller63819443toll__er
troller73913173troll__er
volleyer1443163volleyer
walkover1842943walkover
walloper13147113walloper
wallower14158943wallower
willower14127463willower
wolver12419713wo_l_ver
yellower14186223yellower

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 Filter1786911461620.406440125.6
2DLD Change Limit146162856.82621412.5
3Display Results85850.0332575.8
 (SQL Overall)178691857.26524596.1
 
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.