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

116 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
girting9311333(None) 
airting83616301airting
gifting123810891gifting
girding103611881girding
girning93210691girning
girthing13256081girthing
gitting93215701gitting
agisting1038242agisting
airing74927502air_ing
airthing12297952airthing
birding114014922birding
birling104317052birling
birring103713062birring
birthing14338432birthing
biting95321822bi_ting
bitting103717292bitting
carting104228282carting
citing94220182ci_ting
darting94020662darting
dieting93616832dieting
dinting93520552dinting
dirking133812602dirking
dirling93316072dirling
dirtying1336092dirtying
farting114120752farting
firing104021722fir_ing
firming132811222firming
fisting113818122fisting
fitting113516562fitting
flirting12319012flirting
gaiting93716582gaiting
garbing113613272garbing
garoting10510702garoting
garring93116712garring
gasting95022762gasting
gating84826952g_ating
getting93316562getting
gibbing13339372gibbing
gibing103712352gi_bing
gieing83614852gi_eing
gigging93311772gigging
gilding103813002gilding
gilling93520382gilling
gimping133710762gimping
ginning93313982ginning
gipping133813122gipping
girdling1146822girdling
gittin72910552gittin_
giving114313882gi_ving
glinting103210052glinting
gorging102611362gorging
goring84119572gor_ing
gorming112810832gorming
grating93923182grating
griding103014972griding
grifting13299262grifting
griming113612492griming
griping113012062griping
gritting10309982gritting
gurging102910112gurging
gusting93917162gusting
gutting93415922gutting
gyrating1337452gyrating
gyring113910362gyr_ing
hilting113316892hilting
hinting113919222hinting
hiring104421602hir_ing
histing113720372histing
hitting113017272hitting
hurting113914032hurting
iring66025422_ir_ing
irking114611752_irking
jilting153211742jilting
karting123716062karting
kilting123213852kilting
kirning12319332kirning
kiting114117092ki_ting
kitting123214442kitting
lifting113313272lifting
lilting83515382lilting
linting83820982linting
listing84020592listing
marting103325012marting
milting103619122milting
minting103020812minting
miring93723802mir_ing
misting103623382misting
mitring103514142mitring
parting103527382parting
pirating11314512pirating
pitting103618872pitting
porting103021782porting
quirting18238382quirting
rifting113515002rifting
rioting82716392rioting
shirting123213612shirting
sifting113014592sifting
silting83320482silting
siring75128312sir_ing
siting74126622si_ting
sitting83519632sitting
skirting13289392skirting
sorting83221812sorting
spirting112913632spirting
tarting84222652tarting
tilting83417102tilting
tinting84620602tinting
tiring74023092tir_ing
tirling83315732tirling
wilting113515912wilting
wiring104521022wir_ing
wisting113519742wisting
witing103522822wi_ting
witting113417062witting
writing113713892writing
yirring11307762yirring

Search took 4 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.373479064.3
2DLD Change Limit1076711162.89037256.4
3Display Results1161160.0502320.0
 (SQL Overall)1786911163.31353936.3
 
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.