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

39 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
jagra133817(None) 
jagras1438461jagras
aga410447232_ag_a
agar58726412_agar
agha87417302_agha
agma77623262_agma
agora6914332_agora
agria65517142_agria
aura45836252_aura
dagga839542dagga
eagre64315322eagre
gaga66625552gag_a
jag116542712jag__
jager134318132jager
jagers144415722jagers
jagg136115312jag_g
jaggs148111492jaggs
jaggy175913142jaggy
jags126132792jag_s
jaguar1435282jaguar
jar107646152ja_r_
jarl115828132ja_rl
jarrah1636682jarrah
jars117338352ja_rs
java147316642ja_va
juga126417322jug_a
jura116024892j_ura
labra75415462labra
laura54116202laura
magma104513572magma
mara67444572ma_ra
naira5314742naira
para65242172pa_ra
raga55930812rag_a
sabra75317852sabra
sacra74516992sacra
saga55331172sag_a
tagrag837042tagrag
vara75530882va_ra

Search took 2 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 Filter178691538000.330541487.9
2DLD Change Limit53800391.36039558.8
3Display Results39390.0133000.0
 (SQL Overall)178691391.703104927.2
 
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.