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

91 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
gingelis1024709(None) 
gingeli9286151gingeli_
gingelies11277501gingelies
gingellis11244201gingellis
gingilis10255591gingilis
gingalls1096432gingalls
gingals9109312gingal_s
gingeley13294672gingeley
gingeleys14272892gingeleys
gingelli10304392gingelli
gingellies12233922gingellies
gingelly13305692gingelly
gingely12378212gingel_y
gingers94118642ginge_rs
gingili9306032gingili_
gingillis11213742gingillis
ainsells895403ainsells
angelic1039623_angelic
angels74416173_angel_s
angelus8418463_angelus
bingers104519993binge_rs
binges93923123binge__s
dingers94321383dinge_rs
dinges83825423dinge__s
dingeys12458403dinge_ys
dingles93818323ding_les
finalis103313663fin_alis
fingers113418433finge_rs
gangers94418603gange_rs
ganglia946613gang_lia
gangrels1094973gangrel_s
genesis82510823gen_esis
gigglers11297403gigglers
giggles103312933gi_ggles
giglets93211553gi_glets
gigolos934693gi_golos
gimels938893gi_mel_s
gingal81010153gingal__
gingall9117333gingal_l
ginger84920033ginge__r
gingered11127743gingered
gingering1238873gingering
gingerly13315303gingerly
gingery12368913ginge_ry
ginghams1573903ginghams
gingilli10274413gingilli
gingkoes14404733gingkoes
gingkos13405343ging_kos
ginners84314223ginne_rs
ginsengs1042653ginsengs
grindelia1142293grindelia
grindelias1252113grindelias
gunnels8358563gunnel_s
gunsels8338133gunsel_s
hingers113420213hinge_rs
hinges105121033hinge__s
ingests83210983_ingests
ingles74420873_ing_les
ingulfs1134733_ingulfs
jingalls1685333jingalls
jingals1588073jingal_s
jinglers16408763jinglers
jingles153816383jing_les
kinesis11259593kin_esis
kingless13288693kingless
kinglets13318583kinglets
lingerie959203lingerie
lingeries10511813lingeries
lingers84223303linge_rs
lintels73311163lintel_s
mangels103614493mangel_s
minglers113011293minglers
mingles103719003ming_les
pignolis1146053pignolis
pingers104020743pinge_rs
ridgels9348023ridgel_s
ringers83922953ringe_rs
ringlets92910233ringlets
singers83824703singe_rs
singes74326853singe__s
singles83520433sing_les
singlets93611473singlets
tangelos935743tangelos
tinges74722333tinge__s
tinglers93710593tinglers
tingles83818323ting_les
tinsels738373tinsel_s
wingers113921483winge_rs
wingless122910023wingless
winglets12299593winglets
zingers173514853zinge_rs

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.530337152.8
2DLD Change Limit146162916.97020970.2
3Display Results91910.0332757.6
 (SQL Overall)178691917.53323721.1
 
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.