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

81 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
graylag128311(None) 
graylags1372981graylags
greylag1262551greylag
gravlax1842642gravlax
graying124115882graying
grayling1338002grayling
grayly13287962grayl_y
greylags1392312greylags
braying134416313braying
drayage1234433dray_age
draying123813843draying
drayman1335433drayman
fraying143413433fraying
gala55635163g_a_la_
galago838913g_a_lago
galah95917643g_a_lah
galas65731643g_a_las
galax135314463g_a_lax
galyac1235973g_alyac
galyak1445333g_alyak
gasbag1035413g_asbag
gayal9312713g_ay_al
gayals1039513g_ayals
gaydar1135503g_aydar
gayly124513093g_ayl_y
graal64316503gra__al
graals74112913graal_s
gracing113216443gracing
grading103918713grading
gradual936943gradual
graftage1343683graftage
graham1237853gra_ham
grail64622873grail__
grails77518783grail_s
grama85620283gra_ma_
gramas94317203gra_mas
gramma11499803gramma_
grammar12406893grammar
grammas12499773grammas
grampa115010173grampa_
grampas12399253grampas
grana65722093gra_na_
grandad1038453grandad
grandam1139393grandam
granola837913granola_
granolas938053granolas
granular946893granular
graplin1058443graplin
grappa11396443grappa_
grappas12357103grappas
grating93923183grating
graving123114563graving
gravlaks1642423gravlaks
gray85329893gray___
grayback2043933grayback
grayed115415643gray_ed
grayer106014543gray_er
grayest11489363grayest
grayish1437813grayish
graylings1433883graylings
graymail1443273graymail
grayout1148513grayout
grays95621333gray__s
grazing183514553grazing
greying124110893greying
greyly13316543greyl_y
grillage1055613grillage
gulag7310823g__ulag
haylage1436443_haylage
praying133717323praying
ragbag1045463_ragbag
raglan73711503_raglan
ragtag836643_ragtag
ratbag956563_ratbag
raya75224823_ray_a_
rayah116013503_ray_ah
rayas85922053_ray_as
raying105027193_raying
reflag1098083_reflag
stalag7310023sta_lag
waylay1535453_waylay

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit134027816.41020909.0
3Display Results81810.0302700.0
 (SQL Overall)178691816.83026162.7
 
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.