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

69 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
gingeley1329467(None) 
gingeleys14272891gingeleys
gingelly13305691gingelly
gingely12378211gingel_y
gingeli9286152gingel_i
gingelies11277502gingelies
gingelis10247092gingelis
gingelli10304392gingelli
gingered11127742gingered
gingerly13315302gingerly
gingery12368912ginge_ry
angeled93211513_angeled
dingey114914053ding__ey
dingily1238103dingil_y
dingle84317073ding_le_
dingles93818323ding_les
finely123011563fin_el_y
fingered13128333fingered
fingerer12127223fingerer
gangly113911583gang_l_y
giggle94313513gi_ggle_
giggled114010073gi_ggled
giggler101029883gi_ggler
giggles103312933gi_ggles
giggly12518703gi_ggl_y
giglet83920273gi_g_let
gingal81010153gingal__
gingall9117333gingal_l
gingalls1096433gingalls
gingals9109313gingal_s
gingellies12233923gingellies
gingellis11244203gingellis
ginger84920033ging__er
gingers94118643ginge_rs
gingili9306033gingil_i
gingilis10255593gingilis
gingilli10274413gingilli
gingkoes14404733gingkoes
ingle64120433_ing_le_
ingles74420873_ing_les
jingle143815223jing_le_
jingled164111063jing_led
jingler154311093jing_ler
jingles153816383jing_les
jingly174111933jing_l_y
kinglet123114043king_let
kingly143511303king_l_y
langley1147453lang_ley
lingered10129643lingered
lingerer9118303lingerer
mingle93518783ming_le_
mingled113612733ming_led
mingler104213843ming_ler
mingles103719003ming_les
ringlet82818173ring_let
single74520603sing_le_
singled93914683sing_led
singles83520433sing_les
singlet84120113sing_let
singly104015853sing_l_y
tingle74319063ting_le_
tingled93712803ting_led
tingler83613343ting_ler
tingles83818323ting_les
tingly103815973ting_l_y
tinseled935763tinseled
tinselly1144613tinselly
wingedly1644013wingedly
winglet113115983wing_let

Search took 8 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 Filter1786911461620.186960704.3
2DLD Change Limit146162697.23620199.3
3Display Results69690.0135307.7
 (SQL Overall)178691697.43524033.8
 
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.