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

98 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
gosling9331240(None) 
goaling93515331goaling
godling103513401godling
goslings10297551goslings
boiling103819672boiling
bolling103820882bolling
bossing103714602bossing
bowling133916492bowling
coaling103722822coaling
codling114418952codling
coiling103723452coiling
cooling103422572cooling
coshing134316432coshing
costing104323022costing
cosying134513132cosying
cowling134017422cowling
doling84923132do_ling
dolling93817372dolling
dosing83920272dos_ing
dossing93313272dossing
foaling113515842foaling
foiling113317652foiling
fooling113117372fooling
fouling113315372fouling
fowling143713112fowling
gabling113514542gabling
galling93921962galling
gaoling93314652gaoling
gashing125119232gashing
gasking134415912gasking
gasping113714362gasping
gassing94216332gassing
gasting95022762gasting
gelling93219762gelling
ghosting1336462ghosting
gilling93520382gilling
glossing10278882glossing
goading103112852goading
gobbing132910702gobbing
gobbling14257532gobbling
goblin939502goblin_
goblins1039242goblins
godding113911942godding
godlings11367492godlings
goggling10246282goggling
going75218492go__ing
golfing12368942golfing
gonging103713032gonging
goofing123510632goofing
goosing93314082goosing
gorging102611362gorging
goring84119572go_ring
gorming112810832gorming
gouging103410702gouging
gowning12258832gowning
grossing103111062grossing
growling1348162growling
guiling93214212guiling
gulling94019562gulling
gushing124014222gushing
gusting93917162gusting
holing104025072ho_ling
hosing103421102hos_ing
hosting114318382hosting
howling143413162howling
isling71213882_isling
joshing18519412joshing
jostling16207122jostling
lolling83415772lolling
losing74022872los_ing
moiling103417662moiling
moshing134214882moshing
mossing103915422mossing
noshing114612772noshing
nosing73419842nos_ing
ogling83211882_ogling
oiling74925312_oiling
poling93526502po_ling
polling102920382polling
pooling103219092pooling
posing93922642pos_ing
posting105622242posting
roiling83220452roiling
rolling83620412rolling
rosing73925592ros_ing
sling66028802__sling
soiling83422322soiling
soling74226822so_ling
toiling83219022toiling
toling73926122to_ling
tolling83418562tolling
tooling82918312tooling
tossing83612562tossing
tousling938792tousling
unsling8313642unsling
voling103918022vo_ling
yodling123610252yodling
yowling143610222yowling

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 Limit107671983.33032333.6
3Display Results98980.0303266.7
 (SQL Overall)178691983.73347867.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.