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 “balloting” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

155 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
balloting123838(None) 
allotting1046502_allotting
allowing12369092_allowing
alloying12339142_alloying
ballasting1345292ballasting
balling104424762ball__ing
ballooning1344722ballooning
bellowing1547192bellowing
billeting1236632billeting
billowing1545872billowing
bolloxing1944772bolloxing
bulleting1236642bulleting
fallowing1666432fallowing
galleting1137622galleting
galloping1356252galloping
halloaing1387032halloaing
halloing121510072hallo_ing
hallooing1366342hallooing
hallowing1676942hallowing
palleting1238732palleting
sallowing1357382sallowing
tallowing1366292tallowing
walloping1545592walloping
wallowing1666072wallowing
ablating11311993_ablating
alerting91312383_alerting
allaying12339303_allaying
alleging1038473_alleging
allocating1347383_allocating
alluding1036953_alluding
alluring939073_alluring
allying113011663_all_ying
bailing103723523bail__ing
baiting103918883ba__iting
balancing1435783balancing
balding114015063ba_l_ding
baling94829693ba_l__ing
balking143717353ba_l_king
ballerina1146483ballerina
balletic1248073balleti_c
ballon84117493ballo__n_
ballonne1045243ballo_nne
ballons93916963ballo__ns
balloon93711433ballo_on_
balloonings1452133balloonings
balloons103110523ballo_ons
ballot84624093ballot___
balloted1189043ballot_ed
balloter1078893ballot_er
balloters1157673balloters
ballots94116033ballot__s
ballpoint1345993ballpoint
ballyhooing2071383ballyhooing
balsaming1445123balsaming
basseting1236153basseting
basting104227203ba__sting
bating95132253ba___ting
batting104422273ba__tting
baulking1536003baul_king
bawling133813863bawl__ing
beclothing1843873beclothing
belling103825073bell__ing
bellying14359073bell_ying
belting104119133b_el_ting
billing103823853bill__ing
blasting114013433b_lasting
blatting114111653b_latting
blazoning2144033blazoning
bleating113514503b_leating
bloating113512813b_loating
blooding122410653b_looding
blooming13299433b_looming
blooping13248843b_looping
blotting113910433b_lotting
blowing133813053b__lowing
blunting11319843b_lunting
blurting11258773b_lurting
bolling103820883boll__ing
bollixing1944813bollixing
bolting104416763b_ol_ting
booting103821363b__ooting
bulldozing2342163bulldozing
bulletin1046773bulletin_
bulletins1146333bulletins
bulling104324793bull__ing
bullring11388423bull_ring
bullying14329293bull_ying
calling103826773call__ing
callousing1344273callousing
callusing1236173callusing
collating12312763collating
colleting12311053colleting
dallying13368493dall_ying
dolloping1344993dolloping
faggoting1543313faggoting
fagoting1336283fa_goting
falling113621583fall__ing
faulting12237733faul_ting
fellating1339243fellating
fellowing1655923fellowing
filleting1335843filleting
following1665753following
gallanting1245343gallanting
galling93921963gall__ing
gallying13328933gall_ying
galoping1258023ga_loping
garoting10510703ga_roting
garroting1136953garroting
haloing113814133ha_lo_ing
halting114419073ha_l_ting
helloing12159123hello_ing
hilloaing1375433hilloaing
hilloing12158303hillo_ing
holloaing1385793holloaing
holloing12148823hollo_ing
hollooing1385363hollooing
hollowing1675933hollowing
hulloaing1384523hulloaing
hulloing12146703hullo_ing
hullooing1383993hullooing
lalling83519623lall__ing
lolloping1244683lolloping
looting83019643__looting
malling103623663mall__ing
malting103219083ma_l_ting
mellowing1545893mellowing
palliating1347883palliating
palling104024483pall__ing
palpating1438533palpating
parroting1239153parroting
pelleting1237953pelleting
pillowing1545493pillowing
piloting1139693_piloting
polluting1235703polluting
rallying12289013rall_ying
reallotting1243673reallotting
sallying12309853sall_ying
salting84120793sa_l_ting
saluting9310553sa_luting
salvoing1236423salvo_ing
scalloping1543953scalloping
shallowing1744113shallowing
slaloming1244743slaloming
swallowing1743043swallowing
tableting1236353tableting
tailoring1036403tailoring
tallaging1146483tallaging
tallying12318833tall_ying
valeting1238843va_leting
valuating1338643valuating
vaulting12227223vaul_ting
walling113520973wall__ing
wallopings1652713wallopings
willowing1645323willowing
yellowing1655073yellowing

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.453394461.4
2DLD Change Limit1486411556.40623203.4
3Display Results1551550.0632460.3
 (SQL Overall)1786911556.92225814.9
 
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.