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

380 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
fairings1238819(None) 
airings83913841_airings
failings123811011failings
fairing113614011fairing_
firings114112331f_irings
pairings11398311pairings
airing74927502_airing_
dairyings1442632dairyings
darings93713652da_rings
earings84517712ea_rings
earrings9299632earrings
facings134511262fa_cings
fadings12469302fa_dings
failing113521332failing_
fairies103516042fairi_es
farinas103215232fa_rinas
faring105231282fa_ring_
farmings14298222farmings
fastings124011942fastings
fatlings12359302fatlings
filings115213072f_ilings
finings114311772f_inings
firing104021722f_iring_
fixings18347442f_ixings
furrings12317142furrings
lairing83715342lairing_
mailings113011922mailings
pairing103716732pairing_
parings104219212pa_rings
railings93412152railings
raisings9338442raisings
sacrings11278922sacrings
sailings93513252sailings
tailings93211672tailings
wairing113414312wairing_
waitings123413742waitings
wirings113910112_wirings
ablings1038743_ablings
actings104512463_actings
ageings9437693_ageings
agings86312673_a_gings
aiding84423613_aiding_
ailing74331013_ailing_
aiming94320843_aiming_
airbags1036293_airbags
airiness8412213_airiness
airlines8312793_airlines
airns55521033_air_n_s
airting83616303_airting_
antings85015583_antings
armings103811503_armings
askings12519173_askings
audings9289393_audings
awnings11406713_awnings
backings174012213backings
baggings13307523baggings
bailing103723523bailing_
bairns86710873bair_n_s
baiting103918883baiting_
bakings144312023ba_kings
bankings15489403bankings
baring95135853ba_ring_
barongs105310833ba_rongs
barring104021593barring_
bashings144311243bashings
bastings114214693bastings
battings114010573battings
bearings113912253bearings
birdings12378823_birdings
birlings11359613_birlings
borings103614243_borings
braidings13285903braidings
brings94618433__brings
cairns85313303cair_n_s
calkings15289223calkings
callings113613833callings
campings154010203campings
cannings113710333cannings
cappings15369493cappings
cardings123812633cardings
carinas93622403ca_rinas
caring95137993ca_ring_
carlings114015853carlings
carpings133812383carpings
carvings143810203carvings
casings104013513ca_sings
castings113614053castings
catlings113712043catlings
cavings134712543ca_vings
ceilings11397993ceilings
chairing143110773chairing_
dairies84217733dairi_es
dairying1336353dairying_
dampings14377523dampings
daring84928683da_ring_
darlings103710383darlings
darnings10378553darnings
deairing10311893deairing_
dialings10329823dialings
drivings13265763drivings
eanlings9128473eanlings
earing75235483ea_ring_
earnings9419333earnings
earring83519013earring_
eastings93412953eastings
eatings84616443ea_tings
fabling133413623fabling_
fabrics1436093fabri_cs
facing125321573fa_cing_
fadeins1168503fadein_s
fadging134210243fadging_
fading114821113fa_ding_
faeries104118993faeri_es
fagging133714763fagging_
fagins10513863fa_gin_s
fagotings1443153fagotings
failingly1636123failingly
fainting123312163fainting_
faints94818783fa__ints
fairish1338993fairi_sh
fairness1136563fairness
fairs85825443fair___s
fairways1743873fairways
fairyisms1743073fairyisms
faithing1537153faithing_
faking145520983fa_king_
falling113621583falling_
famines123216263fa_mines
faming124922973fa_ming_
fangs96224073fa___ngs
fanning113615073fanning_
fanzines2036913fanzines
farcing133514003farcing_
farding123716743farding_
farina94618233fa_rin_a
farinha13357063fa_rinha
farinhas14325363fa_rinhas
farinose1136463fa_rinose
farming133515083farming_
farriers113610743farriers
farthings1635233farthings
farting114120753farting_
fascines13310143fascines
fashing144918793fashing_
fasting114522833fasting_
fating105328673fa_ting_
fatling113815683fatling_
fatting113818703fatting_
favoring1596673favoring_
fawning14409133fawning_
faxing175117053fa_xing_
faying134521073fa_ying_
fazing194418643fa_zing_
fearing113520033fearing_
feelings12338933feelings
feltings12317903feltings
fencings14225663fencings
fibrins1238633fibrin_s
ficins113513983f_icin_s
fifing134212343f_ifing_
filing103823763f_iling_
fillings122910503fillings
findings13328443findings
fining104223213f_ining_
firkins1437663f_irkin_s
firming132811223f_irming_
firns86018543f_ir_n_s
fishings15307693fishings
fittings12318203fittings
fixing174813783f_ixing_
flaggings15285183flaggings
flailing12298923flailing_
flaring114116803flaring_
flashings16316663flashings
flatlings13315823flatlings
flavorings1762973flavorings
flings106715283f__lings
flirting12319013flirting_
fliting113514613fliting_
floorings13245093floorings
florins10311643florin_s
flutings12357373flutings
flyings14496063f_lyings
flytings15304793flytings
foiling113317653foiling_
foining113013453foining_
footings12248833footings
forgings13287703forgings
forints10411833f_orints
foulings12327943foulings
fowlings15377243fowlings
foxings18446963f_oxings
fraggings15324243fraggings
framings14338133framings
frayings15325993frayings
frigs96019273f__ri_gs
frillings13265803frillings
fringe104013953f__ringe
fringes113514103f__ringes
fringy13309263f__ringy
frizing203310873frizing_
furring114013143furring_
gaining94015663gaining_
gaiting93716583gaiting_
gamings114610913ga_mings
garring93116713garring_
gaskings14427473gaskings
gassings10438403gassings
gatings95212823ga_tings
gaywings1633193gaywings
gearings10359503gearings
glairing1047283glairing_
hailing113820693hailing_
hairiness1238013hairiness
hairlines1237133hairlines
hairpins1365433hairpin_s
hangings13258583hangings
haring104233003ha_ring_
harpings14379773harpings
hawkings19336133hawkings
hayings14379393ha_yings
hazings20378343ha_zings
hearings123611853hearings
heiring113312903heiring_
herrings12379533herrings
hidings12349703_hidings
hiring104421603_hiring_
icings9428453__icings
iring66025423__iring_
jailing153415843jailing_
jarinas143712183ja_rinas
jarring153613193jarring_
joinings16285243joinings
kartings13418523kartings
lacings105013653la_cings
ladings93814133la_dings
laggings11298403laggings
lakings124713513la_kings
landings103110073landings
lapwings14274973lapwings
lashings124412253lashings
lastings94214423lastings
lathings12469853lathings
latrines8515003latrines
lawings113611473la_wings
layerings13235683layerings
likings12539413_likings
linings84313073_linings
livings11408923_livings
mailing102923343mailing_
maiming122912723maiming_
makings145413163ma_kings
mallings113413093mallings
mappings15296413mappings
marinas93519383ma_rinas
marines93928013ma_rines
markings153410243markings
marlings113713493marlings
marring103319553marring_
maskings15448753maskings
matings104516213ma_tings
mattings11369673mattings
mayings134410513ma_yings
minings103912073_minings
miring93723803_miring_
mirins83918903_mirin_s
moorings11257713moorings
nailing83419963nailing_
oaring74225303oa_ring_
offerings1643653offerings
outrings92811053outrings
packings174310063packings
paddings13297013paddings
pagings114411063pa_gings
paiking143814813paiking_
paining103920243paining_
paintings12327093paintings
palings103915823pa_lings
parangs104314373pa_rangs
pargings123410163pargings
paring94236493pa_ring_
parkings153610683parkings
parring103222063parring_
partings113513733partings
passings11409873passings
pavings134011633pa_vings
pilings103313613_pilings
pipings12338253_pipings
plaitings12296243plaitings
primings13338143primings
quiring17159993quiring_
racings105015133ra_cings
raiding93617593raiding_
railing83325643railing_
raining83922693raining_
raising83220533raising_
raisins72715343raisin_s
rankings13389173rankings
raring74332873ra_ring_
raspings11337853raspings
ratings84217413ra_tings
ravings114614503ra_vings
ridings93412093_ridings
rings65029173___rings
risings83211893_risings
roarings9248293roarings
sabring102614843sabring_
sackings15389633sackings
sacring103115983sacring_
sailing83927373sailing_
saimins9312113saimin_s
saining83621393saining_
saltings92811253saltings
saplings11269803saplings
sarins63932623sa_rin_s
sarongs84511803sa_rongs
savings114412953sa_vings
sayings113610833sa_yings
seisings9398523seisings
seizings18326473seizings
shirrings13245323shirrings
shirtings13276603shirtings
shorings12269483shorings
sidings94011463_sidings
siring75128313_siring_
sizings17378013_sizings
skiings12295733ski_ings
skiorings14243793skiorings
skirtings14274563skirtings
soarings93210393soarings
sorings83817253_sorings
spilings11308813spilings
spiring103918183spiring_
springs104415923_springs
stirrings10224693stirrings
strings84617133_strings
subrings11229883subrings
suitings9288953suitings
tacrines10310563tacrines
tailing82923103tailing_
tailorings1143433tailorings
takings124512573ta_kings
talkings13358403talkings
tannings9268633tannings
tappings13267713tappings
taring73932283ta_ring_
tarring83318303tarring_
tattings9408823tattings
taurines8310553taurines
tidings93810263_tidings
tilings84212793_tilings
timings10279303_timings
tiring74023093_tiring_
tourings9277373tourings
trainings10246723trainings
vailing113817943vailing_
vaporings1544093vaporings
veilings12357313veilings
veinings12306433veinings
vikings15386623_vikings
voicings14274613voicings
waddings14356473waddings
waifing142910893waifing_
wailing113620903wailing_
waistings1352710763waistings
waiting113618953waiting_
waiving14329633waiving_
walkings16327313walkings
waring105029443wa_ring_
warnings12358453warnings
warring113717973warring_
washings15419273washings
waterings13229253waterings
waxings18366453wa_xings
waxwings2232953waxwings
whitings15287063whitings
wiring104521023_wiring_
wrings104012973__wrings
writings12298113writings
yawpings17253583yawpings

Search took 9 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.1561145455.1
2DLD Change Limit1461623807.81318707.5
3Display Results3803800.1402714.3
 (SQL Overall)1786913808.10922036.1
 
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.