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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
airting8361630(None) 
airing74927501air_ing
airthing12297951airthing
girting93113331girting
abating10413972abating
aborting11710252aborting
acting95920982a_cting
aerating92821002aerating
agisting1038242agisting
aiding84423612ai_ding
ailing74331012ai_ling
aiming94320842ai_ming
airings83913842air_ings
airline7315032airline
airtime948062airtime
alerting91312382alerting
anting75827022a_nting
arcing95819642a_rcing
arising83619972arising
arming94719802a_rming
averting122512732averting
aviating12311022aviating
baiting103918882bai_ting
birding114014922birding
birling104317052birling
birring103713062birring
birthing14338432birthing
biting95321822bi_ting
bitting103717292bitting
carting104228282carting
citing94220182ci_ting
dairying1336352dairying
darting94020662darting
dieting93616832dieting
dinting93520552dinting
dirking133812602dirking
dirling93316072dirling
dirtying1336092dirtying
fainting123312162fainting
fairing113614012fair_ing
farting114120752farting
firing104021722fir_ing
firming132811222firming
fisting113818122fisting
fitting113516562fitting
flirting12319012flirting
gaiting93716582gai_ting
gifting123810892gifting
girding103611882girding
girning93210692girning
girthing13256082girthing
gitting93215702gitting
hilting113316892hilting
hinting113919222hinting
hiring104421602hir_ing
histing113720372histing
hitting113017272hitting
hurting113914032hurting
iring66025422_ir_ing
irking114611752_irking
jilting153211742jilting
karting123716062karting
kilting123213852kilting
kirning12319332kirning
kiting114117092ki_ting
kitting123214442kitting
lairing83715342lair_ing
lifting113313272lifting
lilting83515382lilting
linting83820982linting
listing84020592listing
marting103325012marting
milting103619122milting
minting103020812minting
miring93723802mir_ing
misting103623382misting
mitring103514142mitring
painting113614422painting
pairing103716732pair_ing
parting103527382parting
pirating11314512pirating
pitting103618872pitting
porting103021782porting
quirting18238382quirting
rifting113515002rifting
rioting82716392rioting
sainting93215732sainting
shirting123213612shirting
sifting113014592sifting
silting83320482silting
siring75128312sir_ing
siting74126622si_ting
sitting83519632sitting
skirting13289392skirting
sorting83221812sorting
spirting112913632spirting
tainting93613582tainting
tarting84222652tarting
tilting83417102tilting
tinting84620602tinting
tiring74023092tir_ing
tirling83315732tirling
wairing113414312wair_ing
waisting123615212waisting
waiting113618952wai_ting
wilting113515912wilting
wiring104521022wir_ing
wisting113519742wisting
witing103522822wi_ting
witting113417062witting
writing113713892writing
yirring11307762yirring

Search took 6 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 Filter1786911076710.856208751.2
2DLD Change Limit1076711124.23625418.1
3Display Results1121120.0303733.3
 (SQL Overall)1786911125.12234887.0
 
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.