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

62 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
pullovers1412424(None) 
pullover13134641pullover_
allovers1137672_allovers
plovers123611832p__lovers
pullers93618482pull__ers
pushovers1743002pushovers
rollovers1244092rollovers
spillovers1542402spillovers
allover1038583_allover_
balloters1157673balloters
bellowers14177623bellowers
boilovers1444103boilovers
bulldozers2252033bulldozers
clovers125114663__clovers
cullers93418853cull__ers
culvers12329833cu_l_vers
cutovers1335123cu_tovers
flyovers1733673_flyovers
followers15146183followers
fullers103817373full__ers
gallopers12136323gallopers
glovers114310883__glovers
hallowers15137723hallowers
holdovers1643763holdovers
hullers103616263hull__ers
hulloes104113923hullo_e_s
lovers94223433___lovers
lullers73213353lull__ers
mullers93217303mull__ers
outlivers12246153outlivers
outloves11249673outlove_s
palavers1337993p_alavers
pallors9314363pallo__rs
passovers14144753passovers
pillagers12276923pillagers
plover115312613p__lover_
plowers123812243p__lowers
pollers93420023poll__ers
pollsters1137173pollsters
polluters1135033polluters
popovers1595663p_opovers
provers123817793p__rovers
pulers83820283pu_l__ers
puller83820813pull__er_
pullets94015163pull__ets
pulleys12399143pull__eys
pullouts1045223pullo_uts
pulmotors1342803pulmotors
pulpers114612283pu_l_pers
pulsers94213153pu_l_sers
pulsojets1841623pulsojets
purloiners1242813purloiners
pushover1643083pushover_
rollover1144453rollover_
runovers1134473ru_novers
spillover1442623spillover_
turnovers1243283turnovers
uncovers1336573_uncovers
walkovers1942613walkovers
wallopers14136273wallopers
wallowers15127653wallowers
willowers15166693willowers

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 Filter1786911486410.1531167915.0
2DLD Change Limit148641626.67322275.0
3Display Results62620.0134769.2
 (SQL Overall)178691626.83926128.2
 
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.