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

158 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
bantengs113459(None) 
banteng1046361banteng_
antings85015582_antings
bankings15489402bankings
banters94623122bante_rs
bantlings12216602bantlings
bartends1136792bartends
bastings114214692bastings
battens95313262batten_s
battings114010572battings
buntings11348772buntings
actings104512463_actings
anteing8312813_anteing_
antenna746383_antenna
antennas846413_antennas
antes56334323_ante__s
anting75827023_anting_
attends8257593_attends
backings174012213backings
baggings13307523baggings
baiters94619313baite_rs
baiting103918883baiting_
bakings144312023ba_kings
baleens938473baleen_s
bananas93312223ban_anas
bandanas11178573bandanas
bandeaus1146503bandeaus
banders104324563bande_rs
banding114921413banding_
bandogs1138363ban_dogs
banes74945583ban_e__s
bangers104020353bange_rs
banging114019863banging_
bangs85627783ba___ngs
banians9312033banian_s
baning95127833ban_ing_
bankers133919093banke_rs
banking144621353banking_
banners94018713banne_rs
bannets94013843banne_ts
banning103818233banning_
banns75321233ban__n_s
bantams1149063bant_ams
banter84825343bante__r
bantered113313653bantered
banterer102811783banterer
banterers112410013banterers
bantering122414243bantering_
banties94324763bant_ies
bantling112612003bantling_
banyans1237913banyan_s
barongs105310833ba_rongs
barrens94414323barren_s
bartend1038753barten_d
barters94223053barte_rs
bashings144311243bashings
basters94930313baste_rs
bastes85330383baste__s
basting104227203basting_
bates75846343ba_te__s
bating95132253ba_ting_
batons85519423ba_ton_s
batten85217123batten__
battened11259573battened
battener10369403battener
batteners11238183batteners
batters94626023batte_rs
batting104422273batting_
beastings12387653beastings
beatings114113233beatings
beltings11369253beltings
benzenes1946853benzenes
biltongs1133813biltongs
bindings123810473bindings
bittings11339293bittings
blastings12347913blastings
boatings113710113boatings
bondings12369413bondings
brandings13277483brandings
bunters94717123bunte_rs
bunting103718833bunting_
butenes9313033b_utenes
cannings113710333cannings
cantdogs1244043cantdogs
canteens1038573canteens
canters94827733cante_rs
cantinas102713783cantinas
canting104725903canting_
cantons95221203canton_s
castings113614053castings
catenas9313113ca_tenas
contends112810573contends
contents104018213contents
eanlings9128473eanlings
eastings93412953eastings
eatings84616443ea_tings
fastens105511753fasten_s
fastings124011943fastings
fattens105111713fatten_s
gatings95212823ga_tings
gensengs1043093gensengs
ginsengs1042653ginsengs
hangings13258583hangings
hanting114124483hanting_
haptenes133810823haptenes
haptens124511343hapten_s
hastens106214813hasten_s
huntings12328053huntings
intends8239963_intends
intents72115703_intents
kanteles1238123kanteles
kartings13418523kartings
landings103110073landings
lantanas838263lantanas
lanterns838303lanterns
lastings94214423lastings
latens64620213la_ten_s
latents75214313la_tents
lattens75014673latten_s
manteaus1036383manteaus
mantels94515043mante_ls
mantes84430783mante__s
mantlings12207233mantlings
martens93714953marten_s
matings104516213ma_tings
mattings11369673mattings
muntings11289813muntings
paintings12327103paintings
pangenes112612833pangenes
pangens103112073pangen_s
panting104025423panting_
partings113513743partings
patens84820863pa_ten_s
patents94815203pa_tents
pattens95414923patten_s
pentenes10315633pentenes
plantings12348403plantings
quantongs1942313quantongs
rankings13389173rankings
ranters73323643rante_rs
ranting84025413ranting_
ratings84217413ra_tings
rattens74213403ratten_s
saltings92811253saltings
santeras8311063santeras
santeros8311193santeros
satangs8479713sa_tangs
shantungs1341653shantungs
tangents938713tangents
tannings9268633tannings
tattings9408823tattings
tautens7317843tauten_s
tintings9288713tintings
waitings123413743waitings
wanters104420093wante_rs
wanting114220173wanting_
wantons103713013wanton_s
xanthenes1956353xanthenes

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.423422437.4
2DLD Change Limit1461621587.40619735.6
3Display Results1581580.0602633.3
 (SQL Overall)1786911587.88922650.7
 
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.