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

187 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
airbag95696(None) 
airbags1036291airbags
airboat9512132airboat
airbus848342airbus
airing74927502airing
airman82414222airman
airway1237692airway
dirtbag1143022dirtbag
kitbag1334972kitbag
mailbag1243922mailbag
aba512850953a__ba_
abas68642083a__bas
abba810522653a_bba_
abbas95918643a_bbas
abroad9310943abroad
acreage1037843acreage
acrobat11411813acrobat
aerial64625713aerial
aerobat9514473aerobat
agria65517143agria_
agrias74315393agrias
aiding84423613aiding
aidman92410623aidman
ailing74331013ailing
aiming94320843aiming
air38058393air___
airboats1047283airboats
airdate8311323airdate
aired66032923air_ed
airer54927893air_er
airers64922313airers
airest63825263airest
airfare1047243airfare
airhead1136993airhead
airier64619363airier
airily93014823airily
airings83913843airings
airmail946213airmail
airmen82612353airmen
airn46433833air__n
airns55521033air_ns
airpark1344923airpark
airplay1245483airplay
airs46447423air__s
airt45757783air__t
airted74214503airted
airth85621023air_th
airths95414253airths
airting83616303airting
airts55626343air_ts
airward1148133airward
airwave1344433airwave
airways1336243airways
airy75734153air__y
alba68328333a_lba_
albas75925393a_lbas
ambage11510603a_mbage
ameba9312383ameba_
amebae1049633amebae
ameban1039093ameban
amebas10311453amebas
anabas8314083anabas
aorta55922573aorta_
aortae65115473aortae
aortal65217513aortal
aortas65417783aortas
arak86929573a_r_ak
arb510448423a_rb__
arbor74818113a_rbor
arbs66834733a_rb_s
area45843393a_rea_
areae55229743a_reae
areal55928733a_real
areas55935773a_reas
argal65023393a_rgal
arhat8327093a_rhat
aria46245423a_ria_
arias55438023a_rias
arras55626133a_rras
array86317143a_rray
arrear6310253arrear
arriba867683arriba_
arroba898663arroba_
arrobas969213arrobas
artal55525473a_rtal
arval86017013a_rval
atabal839743atabal
atria56022343atria_
atrial65418943atrial
aura45836253aur_a_
aurae54128113aur_ae
aural54428963aur_al
aurar54420253aur_ar
auras55932563aur_as
bag67059223___bag
barbal104016663barbal
brag75229723_br_ag
circa9311403circa_
corban10314693corban
crag75625303_cr_ag
darbar959953darbar
debag94212303_debag
diram84419473dir_am
dirham12378273dirham
dirtbags1242703dirtbags
disbar938513disbar
dorbug1034953dorbug
drag64825053_dr_ag
durbar968723durbar
fairing113614013fairing
fairway1644333fairway
ferbam1339003ferbam
firebug1383793firebug
firing104021723firing
firman112211343firman
forbad122710503forbad
frag85126273_fr_ag
garbage1138053garbage
garbagy1444243garbagy
gasbag1035413gasbag
gimbal11228813gimbal
hairball1344633hairball
hairband1444573hairband
haircap14134753haircap
handbag1495863handbag
herbage1337003herbage
herbal112513493herbal
hiring104421603hiring
iring66025423_iring
isba61310883_isba_
isbas71010403_isbas
kitbags1443883kitbags
lairing83715343lairing
libra74712423libra_
librae84310173librae
libras83711703libras
limba95414983limba_
limbas105313203limbas
lira46928683lir_a_
liras56021983lir_as
mailbags1343903mailbags
mimbar1297493mimbar
mirage92313653mir_age
miring93723803miring
mirza16410443mirza_
mirzas1738183mirzas
naira5314743nair_a_
nairas6312783nair_as
pairing103716733pairing
pibal95217323pi_bal
pirog83913673pir_og
rag45761323__r_ag
ragbag1045463ragbag
ratbag956563ratbag
rurban849043rurban
sandbag11106243sandbag
scrag85916173scr_ag
seabag938473seabag
sirdar7269103sirdar
siring75128313siring
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
sprag86418693spr_ag
tagrag837043tagr_ag
timbal102510753timbal
tiring74023093tiring
tribal8611133tribal
turban8310483turban
urban72013863_urban
verbal112513663verbal
virago1046643vir_ago
viral86419593vir_al
virga9310253virga_
virgas1048883virgas
wairing113414313wairing
wigwag1443723wigwag
windbag1444123windbag
wiring104521023wiring
wirra83210823wirra_
workbag1742923workbag
yerba101010763yerba_
yerbas11119293yerbas
zariba1736983zariba_
zaribas1836043zaribas
zigzag1642963zigzag
ziram163912893zir_am

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161875.61020092.0
3Display Results1871870.0632968.3
 (SQL Overall)1786911876.06329472.4
 
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.