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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
dairyings144263(None) 
dairying1336351dairying_
airings83913842_air_ings
darings93713652da_r_ings
darlings103710382da_rlings
darnings10378552da_rnings
fairings12388192fair_ings
pairings11398312pair_ings
airing74927503_air_ing_
airlines8312793_airlines
airting83616303_airting_
armings103811503_a_rmings
birdings12378823_birdings
birlings11359613_birlings
cardings123812643ca_rdings
carlings114015863ca_rlings
carpings133812393ca_rpings
carrying14148373carrying_
carvings143810213ca_rvings
dabblings15193883dabblings
dairies84217733dair_i_es
dallying13368493dallying_
dampings14377523da_mpings
daring84928683da_r_ing_
darking134217343da_rking_
darklings1533983darklings
darling93418363da_rling_
darning93817333da_rning_
darting94020663da_rting_
deairing10311893deair_ing_
decrying15237413decrying_
deifying1637633deifying_
dialings10329823d_ialings
diallings1134993diallings
diggings12316623d_iggings
dirking133812603d_irking_
dirling93316073d_irling_
dirtying1336093d_irtying_
drillings11285823drillings
drinkings15244773drinkings
drippings15313903drippings
drivings13265763dri_vings
drying113411603d__rying_
dyings11478133d___yings
earings84517713ea_r_ings
earnings9419333ea_rnings
earrings9299633ea_rrings
failings123811013fai_lings
fairing113614013fair_ing_
fairyisms1743073fairyisms
farmings14298223fa_rmings
firings114112333_fir_ings
hairlines1237133hairlines
hairpins1365433hairpin_s
harpings14379773ha_rpings
harrying15157643harrying_
hayings14379393ha__yings
kartings13418523ka_rtings
lairing83715343lair_ing_
mailings113011923mai_lings
markings153410243ma_rkings
marlings113713493ma_rlings
marrying14157233marrying_
mayings134410513ma__yings
paintings12327093paintings
pairing103716733pair_ing_
pargings123410163pa_rgings
parings104219213pa_r_ings
parkings153610683pa_rkings
parrying14168133parrying_
partings113513733pa_rtings
quarryings2371763quarryings
railings93412153rai_lings
raisings9338443rai_sings
rallyings13313633rallyings
sacrings11278923sacr_ings
sailings93513253sai_lings
sayings113610833sa__yings
shirrings13245323shirrings
shirtings13276603shirtings
skirtings14274563skirtings
stirrings10224693stirrings
tailings93211673tai_lings
tarrying12146723tarrying_
varying1429723va_rying_
wairing113414313wair_ing_
waistings1352710763waistings
waitings123413743wai_tings
warnings12358453wa_rnings
wirings113910113_wir_ings

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 Filter1786911486410.436409841.7
2DLD Change Limit148641907.67319372.0
3Display Results90900.0303000.0
 (SQL Overall)178691908.13921954.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.