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

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

88 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
girning9321069(None) 
ginning93313981ginning
girding103611881girding
girting93113331girting
kirning12319331kirning
airing74927502air_ing
airting83616302airting
barning104320352barning
binning103615452binning
birding114014922birding
birling104317052birling
birring103713062birring
brining103216472brining
burning104215502burning
corning103720122corning
darning93817332darning
dining84525132di_ning
dinning93416552dinning
dirking133812602dirking
dirling93316072dirling
durning93511732durning
earning83418212earning
fining104223212fi_ning
finning113615112finning
firing104021722fir_ing
firming132811222firming
gaining94015662gaining
garbing113613272garbing
garring93116712garring
gibbing13339372gibbing
gibing103712352gi_bing
gieing83614852gi_eing
gifting123810892gifting
gigging93311772gigging
gilding103813002gilding
gilling93520382gilling
gimping133710762gimping
ginnings10366522ginnings
gipping133813122gipping
girdling1146822girdling
girthing13256082girthing
gitting93215702gitting
giving114313882gi_ving
gorging102611362gorging
goring84119572gor_ing
gorming112810832gorming
gowning12258832gowning
griding103014972griding
griming113612492griming
grinding1139862grinding
grinning1037862grinning
griping113012062griping
gunning93413172gunning
gurging102910112gurging
gyring113910362gyr_ing
hiring104421602hir_ing
horning113015002horning
inning73617632_inning
iring66025422_ir_ing
irking114611752_irking
ironing82414012_ironing
kerning124010892kerning
kilning12289022kilning
limning103710322limning
lining74526802li_ning
mining94225452mi_ning
miring93723802mir_ing
morning103215042morning
pining93726532pi_ning
pinning103417852pinning
rinning83216742rinning
signing92713962signing
sinning83918442sinning
siring75128312sir_ing
sorning83116812sorning
tining74927542ti_ning
tinning83117282tinning
tiring74023092tir_ing
tirling83315732tirling
trining82919212trining
turning83713182turning
vining104619462vi_ning
warning113717092warning
wining103625052wi_ning
winning113516552winning
wiring104521022wir_ing
yarning113512952yarning
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.1261418182.5
2DLD Change Limit107671883.06335152.1
3Display Results88880.0302933.3
 (SQL Overall)178691883.21955511.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.