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

215 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
ballute93854(None) 
ballutes1037521ballutes
allude73910902_allude
allure63012942_allure
ballade104012562ballade
ballet84733972ballet_
ballets93719512ballets
ballot84624092ballot_
balloted1189042balloted
balloter1078892balloter
ballots94116032ballots
bullate93415072bullate
gallate83417122gallate
pollute937382pollute
salute64418022sa_lute
vallate103016562vallate
ablate82219213_ablate
ablaut8313263ablaut_
ablauts936083ablauts
abluted10188363_abluted
absolute1044483absolute
acute74720363_a_cute
alate55340323_a_late
albite8313313_albite
allee54932123_all_ee
allege74314653_allege
allele64514563_allele
allot54933873_allot_
allots64019173_allots
alluded9327093_alluded
alludes83610333_alludes
allured8299173_allured
allurer7348433_allurer
allures72913113_allures
almuce10348213_almuce
almude9399933_almude
alulae6312743_alulae
aplite8316393_aplite
arbute8311043_arbute
astute6310763_astute
baccate131011263baccate
baglike14338943baglike
baguet9316103ba_guet
bailee84526013bail_ee
bailie83818363bail_ie
bailout9414133bailout_
bailouts1036613bailouts
bakelite1447253bakelite
balance11510263balance
balata8614673ba_lata
baldpate1345483baldpate
bale66353843ba_l__e
balkline1437973balkline
ball66043323ball___
ballad94315323ball_ad
ballades114211643ballades
ballads104212913ballads
ballast9313993ballast
ballasted1245453ballasted
ballaster1145973ballaster
ballasts1037933ballasts
balled94926893ball_ed
baller83825203ball_er
ballers94421013ballers
balletic1248073balletic
ballgame1343653ballgame
ballies93725743ballies
balling104424763balling
ballista1045803ballista
ballistae1143793ballistae
ballon84117493ball_on
ballonet10314503ballonet
ballonne1045243ballonne
ballons93916963ballons
balloon93711433balloon
balloters1157673balloters
balls76236413ball__s
ballsier1036523ballsier
ballsy11508873ball_sy
bally105530103ball__y
balmlike1655353balmlike
baluster1037053baluster
banquet1839783banquet
barbate11314543barbate
barbule1137943barbule
barbut104617003barbut_
barbuts11439843barbuts
barite84224813ba_rite
barque17239553barqu_e
baryte115312883ba_ryte
bascule1136573bascule
basque17259083basqu_e
baste74829983ba__ste
bate66552423ba___te
batiste939743batiste
batlike133311883batlike
battue84311003battu_e
bauxite1635573bauxite
belle75827833bell__e
billet86029723billet_
billeted1137643billeted
billeter1037563billeter
billets94516153billets
billie85019173bill_ie
blate75933783b__late
blite76225353b__lite
blouse84714723b_louse
blue65328463b__lu_e
bluet75631193b__luet
blume95619893b__lume
bolete8519613b_olete
brute75321783b__rute
bullace113410673bullace
bullae83416163bull_ae
bullet84528613bullet_
bulleted1138393bulleted
bullets93516393bullets
bute66739673b___ute
calcite11413783calcite
callee84327293call_ee
callet84536763callet_
callets93821703callets
callose9313663callose
callus85317073callu_s
callused1135853callused
calluses1039323calluses
calotte9510563calotte
calque17289843calqu_e
cellule936523cellule
collate92919683collate
collude10337993collude
dilute72911803_dilute
elute54822573__elute
evolute1045683evolute
failure1035753failure
falcate12311613falcate
fallout10313503fallout_
fallouts1137883fallouts
fellate10313433fellate
flute86823753__flute
galeate83916783galeate
galette84212693galette
gallates92815523gallates
gallet73630853gallet_
galleta8399643galleta
galleted1038213galleted
gallets83517403gallets
gallnut847253gallnut_
gallnuts943923gallnuts
gallus74313203gallu_s
gallused1034193gallused
galluses936963galluses
glute66020903__glute
halite93624233ha_lite
hallot95426783hallot_
halloth134111253halloth
halluces1335613halluces
hallux1637363hallu_x
halutz1868853ha_lutz
haplite12310703haplite
haute89521613ha__ute
illite63414923_illite
illude7327503_illude
illume8298223_illume
lute46341013___lute
malamute1245893malamute
malate84624553ma_late
maleate94117543maleate
malemute1244923malemute
mallee84525593mall_ee
mallet84433053mallet_
mallets93318493mallets
marlite92917073marlite
mullite9313013mullite
obvolute1342543obvolute
palate84226783pa_late
paleate94120003paleate
palette93613983palette
pallet84232653pallet_
palleted1139873palleted
pallets93919303pallets
pallette1039513pallette
palliate10311893palliate
palmate113215233palmate
palpate113213923palpate
polluted1135433polluted
polluter1035403polluter
pollutes1037613pollutes
ralline73518413ralline
rallye95110163rall_ye
sallet63734543sallet_
sallets73719653sallets
saluted84511713sa_luted
saluter73512453sa_luter
salutes73716253sa_lutes
saute55028083sa__ute
solute64016663_solute
tallage82712073tallage
tallit63422733tallit_
tallith102913063tallith
tallits73215993tallits
tillite7313563tillite
valuate102512733valuate
value85719093va_lu_e
valuta938743va_luta
valvate133710813valvate
valvule1343663valvule
veloute1037733veloute
volute93912763_volute
wallet93327093wallet_
wallets103914833wallets
walleye1336243walleye
wallie93216803wall_ie
walnut939433walnut_
walnuts1033843walnuts

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.390458182.1
2DLD Change Limit1340272156.83019623.3
3Display Results2152150.0802687.5
 (SQL Overall)1786912157.30024478.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.