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

48 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
grippe11531032(None) 
gripe84622961gri_pe
gripped13419341gripped
gripper124410711gripper
grippes124810371grippes
gripple12416611gripple
grippy14447761grippy
cripe95521142cri_pe
cripple13378582cripple
dripped13408082dripped
dripper12349232dripper
drippy14445652drippy
frappe13286952frappe
gipped124815902g_ipped
gipper114215302g_ipper
grape84824662gr_ape
grappa11396442grappa
grapple12378002grapple
gride75223582gri_de
grieve1047242grieve
griffe13438092griffe
grille74315742grille
grilse7399502grilse
grime85021322gri_me
grip76127022gri_p_
griped104114712griped
griper94114612griper
gripes94619872gripes
gripey124111202gripey
gripier103210322gripier
gripmen1235032gripmen
grippers13358132grippers
grippier1355202grippier
grips85520132gri_ps
gript85126172gri_pt
gripy115115252gri_py
grope84821612gr_ope
guimpe1134722guimpe
ripe66038922_ri_pe
ripped114419012_ripped
ripper103518652_ripper
ripple103413912_ripple
tripe75425382tri_pe
triple84215922triple
tripped123911692tripped
tripper113711922tripper
trippet113714112trippet
trippy13457802trippy

Search took 3 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 Filter178691825510.346516448.0
2DLD Change Limit82551482.48333246.5
3Display Results48480.0163000.0
 (SQL Overall)178691482.84562808.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.